function [A] = data_pre

data_all = xlsread('unit_size.xlsx');
data = load('data.txt');
% a = 0;
% for i = 1:size(data,1)
%     a=a+data(i,2);
% end
A = [];

for i = 1:size(data,1)
    for j = 1:size(data_all,1)
        if data(i,1) ~= 0 && data(i,1) == data_all(j,1)
            A = [A;data_all(j,:)];
        end
    end
end

data(all(data==0,2),:)=[];
A = [ones(size(data,1),1) A];% -2

for i = 1:size(A,1) 
    A(i,6) = data(i,2);
end

end


